How to: Change chart values.
Solution:
Change the data in the worksheet.
1) Select the worksheet.
2) Replace the existing data with the new data in the worksheet.
NOTE: The related chart value is automatically adjusted. The corresponding data marker in the chart reflects the change.